UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xd9AR1q6NKRWM8H2m0oQurE59pZnzCtgn8UXm/RUlgI='
WHERE
key_id = '7174e18ecb8e8a85549de8ece787774cc843c1cdf3e9ce8af353d1312c11dd74'
AND (
token = 'Xd9AR1q6NKRWM8H2m0oQurE59pZnzCtgn8UXm/RUlgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)