UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BSnou9Qp/YLFcdWBp5t1FRh/yILEapVj7s0OJQRM2dI='
WHERE
key_id = '3133c6ef5837a61b58a638d908d4a0e40b7364df5c11f9573caccba73fbb4b5c'
AND (
token = 'BSnou9Qp/YLFcdWBp5t1FRh/yILEapVj7s0OJQRM2dI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)