UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ctravJwBDChuKqtQWPAVIDD9/MuFV/gO2eDlqekZXZI='
WHERE
key_id = 'f8d4cc8f25282c0407f9c90f5687b039d8d251b8d8319efe5bb4dd7fcbb50a63'
AND (
token = 'ctravJwBDChuKqtQWPAVIDD9/MuFV/gO2eDlqekZXZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)