UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '54MRgunT9wiXmk40x8ZpEBBt5CuqAQf3J9NG8xMpJzM='
WHERE
key_id = '71815f1d9aceabd75967ab8cf79dcfb4931349fcea2b7e52b134845b5c470173'
AND (
token = '54MRgunT9wiXmk40x8ZpEBBt5CuqAQf3J9NG8xMpJzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)