UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5pqg+UDLN5O4bjHZsHEARHqzF9nnwp6fhsyGsj6zpX0='
WHERE
key_id = '267a67c48c714c71cd1f738396f418e2aba1b4968cad954470e266013c307d45'
AND (
token = '5pqg+UDLN5O4bjHZsHEARHqzF9nnwp6fhsyGsj6zpX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)