UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3y9Atb4TxAejuD9V1W0jQ6Z6rHKlIOr3ApZSplIjyDA='
WHERE
key_id = '0ec74680992d250d8495bfba06885a63590a37e1449d7754fc816b339b8479cd'
AND (
token = '3y9Atb4TxAejuD9V1W0jQ6Z6rHKlIOr3ApZSplIjyDA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)