UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3CJPE9QeoDuJE+0miEYtTYN6Ph5s4T25DweMjeyAfl8='
WHERE
key_id = 'b0d7a26bf4a04112d92c156cc44e23b627f116f6325a1afe01e55326eef3db02'
AND (
token = '3CJPE9QeoDuJE+0miEYtTYN6Ph5s4T25DweMjeyAfl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)