UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NpTSAMqWV0gg1wSqdrLgGy4cqlhUaqGR3DEp6dz+VUI='
WHERE
key_id = '3ca7d894e337933483ac62dfb0886e858bb0c1f7036d83d8356c5bb461b9b97e'
AND (
token = 'NpTSAMqWV0gg1wSqdrLgGy4cqlhUaqGR3DEp6dz+VUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)