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