UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PhcfdkCdY78ftznez21Bha7nFoPCau0d9ICDOGtGvJk='
WHERE
key_id = '338da9e0052f6a33842e82346b3c17952c503644f882dbb06195958e94a3eb49'
AND (
token = 'PhcfdkCdY78ftznez21Bha7nFoPCau0d9ICDOGtGvJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)