UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PwrW4OvdInts0f4o11F/EkWbwQ4ZOBVo7Bw1MxaUtI0='
WHERE
key_id = '1119b7708e07a0123cee8cd85a342156738d47c967dfa36d2d040047331f9b58'
AND (
token = 'PwrW4OvdInts0f4o11F/EkWbwQ4ZOBVo7Bw1MxaUtI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)