UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bgqmf9YALILAYjVnoX6lJX0arhXskFsYHuBiMn80qdw='
WHERE
key_id = 'bb98bceee4542c4f3c311be73ab24281a9feaa73deafa17efd80adf97969d7ff'
AND (
token = 'Bgqmf9YALILAYjVnoX6lJX0arhXskFsYHuBiMn80qdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)