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