UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gQ6LmljnP3AfZKlNxLLFi+7DgXjL7w5OTWc/EI5wiBY='
WHERE
key_id = 'd8610c3de5cc5f87c8a25b09ad37251f83dfa14c856ee0273a0b047190366071'
AND (
token = 'gQ6LmljnP3AfZKlNxLLFi+7DgXjL7w5OTWc/EI5wiBY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)