UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZXX1VxGFIEdzdX3j3dQiMfXLEqqRckZZ9YrQfugxQE='
WHERE
key_id = '9efb3e7e89f58ad1caa611f7497f5cd4d804802e5c5698fe1533a1cb36faa301'
AND (
token = 'nZXX1VxGFIEdzdX3j3dQiMfXLEqqRckZZ9YrQfugxQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)