UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAn9P+TKpSSCNo3hUh0LxjHBlRuSy5KrEI9lSZopLec='
WHERE
key_id = '46afb9a778e19b633553d623b4fb06e5630d718ebaa3c834c916e3153964045a'
AND (
token = 'KAn9P+TKpSSCNo3hUh0LxjHBlRuSy5KrEI9lSZopLec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)