UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MNlADNsJtx6o1dHvkxJIt8ppAPDSLE8cLMNXoAagaRg='
WHERE
key_id = 'bf6e51dae0e0dd4d77ba9ab6491085a5251b6d91b0976b38fc9529a752ca15d8'
AND (
token = 'MNlADNsJtx6o1dHvkxJIt8ppAPDSLE8cLMNXoAagaRg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)