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