UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRUZppCPw5qwREGJnVBbgcZsKdvf9aX/NkmL61ylw4g='
WHERE
key_id = '3a7a6ebe474085ed35aa63efee1d2110e3b6776868f943d52266c02b513d4fa7'
AND (
token = 'pRUZppCPw5qwREGJnVBbgcZsKdvf9aX/NkmL61ylw4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)