UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxT7Dj5uljD1ND7KjNHR4sBCd/GPNr2MfJt9CXG3wWk='
WHERE
key_id = 'a7ffcbe0c4cf5a6b26ed9ecccdd3220de19a83ae41e74f9a81dad5b326f122d0'
AND (
token = 'zxT7Dj5uljD1ND7KjNHR4sBCd/GPNr2MfJt9CXG3wWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)