UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vtel1M/oVr56CQLR8MdaAvjAobPXkxQM1o71InB8JDU='
WHERE
key_id = 'a256ed55918a6718bccc8bdf8f408473a2d0567f52aa49d8eb8bdd4b4a09a547'
AND (
token = 'Vtel1M/oVr56CQLR8MdaAvjAobPXkxQM1o71InB8JDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)