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