UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nD7WbWsMl0wWWLtM9mcT5YQee5SbQZ/43X3I+pKJvEQ='
WHERE
key_id = 'a52fa2cf8819d4f808fea67b7fb66aa1ce75ab2a064327a94b6b9e1f24ebcd70'
AND (
token = 'nD7WbWsMl0wWWLtM9mcT5YQee5SbQZ/43X3I+pKJvEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)