UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ni0Fw+FbQyqIiU4CAtSfNK/3Xhs1zvja9hkUkiI+iI='
WHERE
key_id = '2b8f79b9b28437502f8c1a27acaa402f7a7098d9a50d5371e40b3ce97a8adee6'
AND (
token = '8ni0Fw+FbQyqIiU4CAtSfNK/3Xhs1zvja9hkUkiI+iI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)