UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lR9td48mH8kFb7YOiAx6gs5CItiwo54sg54kNVcQiK4='
WHERE
key_id = 'a21bc9ac4643087fa78604430ea58a6ebb1d00cf12af0d4c4270450f28f24a1d'
AND (
token = 'lR9td48mH8kFb7YOiAx6gs5CItiwo54sg54kNVcQiK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)