UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zX/5ade1ZNxN1ON5ujtRHaQZmS9EDUPXTl5W3yj2phQ='
WHERE
key_id = '9af78ae3fbb5240522e9b2f32501af105749936530ab7c66f84e2fe162e6a2fc'
AND (
token = 'zX/5ade1ZNxN1ON5ujtRHaQZmS9EDUPXTl5W3yj2phQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)