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