UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CUPFLW91AxFHuIjmDgbrpi7vNP2C8zoIxp0obcB2Mw='
WHERE
key_id = '0cbccb9263bb1f61ad18827bba1ab851f5a9b156c945e4c903594c77c80199d0'
AND (
token = '/CUPFLW91AxFHuIjmDgbrpi7vNP2C8zoIxp0obcB2Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)