UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'al6pHUDQROvm/F39NmWnqRgzGixIiNBCN0zK2tSiNA4='
WHERE
key_id = 'f95fd0baf1a2ee90e229b8205a952a4d72e746e789a8a84996e5ab445f262368'
AND (
token = 'al6pHUDQROvm/F39NmWnqRgzGixIiNBCN0zK2tSiNA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)