UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WCmzNskPVX6yXL9Tn5AWfdjt1pf/Y7ZqYN8lPiO5Ewk='
WHERE
key_id = 'ccba4ee0bb5e93b6e81bc26eed449623088f4feae0237529ab6f81b7506eeca4'
AND (
token = 'WCmzNskPVX6yXL9Tn5AWfdjt1pf/Y7ZqYN8lPiO5Ewk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)