UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '06NabpdWX3l63KWUvcJq6vefixKQYr/UvHCx0CFitRM='
WHERE
key_id = '31ca6cc47cdbf8093daa6829a976830a6232a9703eb460c5e1ccf1cce14e34df'
AND (
token = '06NabpdWX3l63KWUvcJq6vefixKQYr/UvHCx0CFitRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)