UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EF9cSmYK/kvB47NU/ddVxYsYxkUyhX02rOwj0d/N5gc='
WHERE
key_id = 'bffedb59b43d9fad09a537ceab92385f675622bdead507e56666a14be2f4dbf4'
AND (
token = 'EF9cSmYK/kvB47NU/ddVxYsYxkUyhX02rOwj0d/N5gc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)