UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPcC5j3Ooiqm+98SmRn1tKXsYppj52y+pyHkAXaUiM4='
WHERE
key_id = '47ae7a5e9bba1b97c066bec72a5f09c00209beb3cdc6931908c20afdede27537'
AND (
token = 'BPcC5j3Ooiqm+98SmRn1tKXsYppj52y+pyHkAXaUiM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)