UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i+qNXawxkAoDJZJ9gwdXAse4OmqunP4Q0XggrLpwcQY='
WHERE
key_id = '642974251ea578a68e5424cbea1c0411994ac58709cb1c103f181c40c278b93b'
AND (
token = 'i+qNXawxkAoDJZJ9gwdXAse4OmqunP4Q0XggrLpwcQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)