UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zq2+vDErNj4P3P1o8Rqj5WkrcaLXTt2Mw7X62BOOiqU='
WHERE
key_id = 'db23d99a3bde4c70b2a1db365308848e854545321f2a4c75a33903b3520b3750'
AND (
token = 'zq2+vDErNj4P3P1o8Rqj5WkrcaLXTt2Mw7X62BOOiqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)