UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9kyXzrHqcQw25xtO+OBkJcoJYFrEXxU1De9nETu4PVk='
WHERE
key_id = '0ec469d6d933638bcb916ad704cbfeec315395b3285e2ef0e999da0e0b0274c4'
AND (
token = '9kyXzrHqcQw25xtO+OBkJcoJYFrEXxU1De9nETu4PVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)