UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yD46q5nM0G8AEKXrVR562xMlb1XxVmEdBUozgTIvveI='
WHERE
key_id = '72c1f07fa9f382c10338923b3305d453495be3b049b653d5fd78aef977ffcda5'
AND (
token = 'yD46q5nM0G8AEKXrVR562xMlb1XxVmEdBUozgTIvveI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)