UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k+f3nbF7v7pMjPTGVpva21u8r72F+ti/a8UrVSoRlbI='
WHERE
key_id = '304b616a1d55e2265b120841eb9998fc298b0571a195acb4f2402a8cc2663386'
AND (
token = 'k+f3nbF7v7pMjPTGVpva21u8r72F+ti/a8UrVSoRlbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)