UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78Kielj8hROSK1P6cC3pG5kclItRjXoq/d1aj1i44BM='
WHERE
key_id = '9d7ec160860de73e02895bba31491a4928b46db6a5572fb0c674ecc71cb4bc93'
AND (
token = '78Kielj8hROSK1P6cC3pG5kclItRjXoq/d1aj1i44BM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)