UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8LHrv79s7/6DJ99DBfeRVq5sHtKrIh6UOJFEdrC6WE='
WHERE
key_id = '9f7516119f0b8fdb8afd804eab763d470abe85704c08f1131268d57a7df69926'
AND (
token = 'X8LHrv79s7/6DJ99DBfeRVq5sHtKrIh6UOJFEdrC6WE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)