UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hl1/KyzHcZbr0YzeKlQxxiZjz0BsKCm1889Jnb2a7fQ='
WHERE
key_id = '0e0827f7618af44fe5c887ced96398127b0a69d78a463985554df34e5e13b358'
AND (
token = 'hl1/KyzHcZbr0YzeKlQxxiZjz0BsKCm1889Jnb2a7fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)