UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2hxqzNGKSBpmICS1GyDbBeCS5QNHR+zOlIQp+thoJGE='
WHERE
key_id = '20ab21d7e8a1782666d3df830f16e68c3af50d335f95bfd423b137a278700743'
AND (
token = '2hxqzNGKSBpmICS1GyDbBeCS5QNHR+zOlIQp+thoJGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)