UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kA7NBdzDpqx7RfFTYrV7zlvZ24NXYx2xn/G5L9cagDg='
WHERE
key_id = 'cae78c915ffc0fad38393d3c6d3c5303eeaa563ce17a99371672ecd88d3a6e8b'
AND (
token = 'kA7NBdzDpqx7RfFTYrV7zlvZ24NXYx2xn/G5L9cagDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)